Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sync00
Starting Member
24 Posts |
 Posted - 2009-09-30 : 11:18:37
|
| I'm working with a third party Point of Sale system that currently has an Access back end. I've written reports and utilities for this using Access.The POS vendor has now switched to a SQL Server back end. I started converting the Access database to use the new SQL Server database. I discovered that some of the tables use a long int data type. Access can handle the field but not when it is used as a primary key.This system is only a small part of my responsibilities. I do not expect to spend much development time on it after the conversion is completed. I'm trying to figure out if it makes sense to learn SQL Server well enough to use Access in SQL passthrough mode. Is there another front end that would be easier to work with? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Should I switch from Access to another front end?