Removing link between Access & Excel

[The New Boy]

I have created an Access front end on to an Excel spreadsheet.

I created a Primary key at a late stage of the build and cannot get Access to save the Primary key as an Auto Number.

I also have problems that certain field formats in Access don't work because of conflicts with Excel.

I have deleted the linked table from Access then changed the format in Excel. I then got External data and linked Access to the same updated Excel spreadsheet. This didn't work.

How can i change formatting in Access when it won't let me save the correct disciplines in Table Form (Access) because i can't save when the Access / Excel tables are linked?

 

[dsdavids]

Denis is right on. That is exactly what I was suggesting.

To send, update or delete data in the Access database I would use VBA, creating modules to complete each process, then refresh the data in Excel when complete. I could spell out some of the basic coding but you would at least have to be familiar with using the VB Editor and using code in your workbook in order to implement it.


Dean